<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="edu.sctu.User" %>
<%@ page import="edu.sctu.Database" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
  <head>
    <title>用户信息</title>
  </head>
  <body>
  <style type="text/css">
    table{
      border-collapse: collapse;
    }
    td{
      border: 1px solid #000;
      padding: 10px;
    }

  </style>
  <h2><a href="userEdit01.jsp">添加用户</a></h2>
  <table>
    <tr>
      <td>编号</td>
      <td>用户名</td>
      <td>密码</td>
      <td>操作1</td>
      <td>操作2</td>
    </tr>
<%
      Database database=new Database();
      List<User> userList=database.userList();
      request.setAttribute("userList",userList);
  %>
      <c:forEach var="user" items="${userList}">
          <tr>
              <td>${user.id}</td>
              <td>${user.username}</td>
              <td>${user.password}</td>
              <td><a href="userDelete.jsp?id=${user.id}">删除</a></td>
              <td><a href="userEdit.jsp?id=${user.id}&username=${user.username}&password=${user.password}">更新</a></td>
          </tr>

      </c:forEach>

  </table>

  </body>
</html>
